package com.example.java2e.Dao;

import com.example.java2e.Entity.Message;
import com.example.java2e.Entity.Notice;
import com.example.java2e.Entity.Tip_off;
import org.apache.ibatis.annotations.Mapper;

import java.util.Date;
import java.util.List;

@Mapper
public interface NoticeDao {
    public void insertNewNotice(Notice notice);
    public void deleteNotice(String title, String date);
    public List<Notice> selectAllNotice();
    public Notice selectNoticeByTitleAndDate(String title, String date);
    public List<Notice> selectNoticeForUser(String id);
    public Notice selectNoticeByTitle(String title);
    public List<Message> selectAllMessage();
    public Message selectMessageByIdReply(Long id_reply);
    public List<Message> selectMessageByIdSend(String id_send);
    public Message selectMessageByTitleDateAndIdSend(String title, String date, String id_send);
    public void insertNewMessage(Message new_message);
    public void modifyIdReply(Long id, Long id_reply);
    public Message selectMessageById(Long id);
    public void insertNewTipOff(Tip_off tip_off);
    public void deleteTipOffByDriverStuAndDate(String id_driver, String id_stu, String date);
    public List<Tip_off> selectAllTipOff();
    public void modifyTipOffCondition(String id_driver, String id_stu, String date, int new_condition);
    public Tip_off selectTipOffByDriverStuAndDate(String id_driver, String id_stu, String date);
}
